﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using CardLogistics.Web.Components;
using System.Text;

namespace CardLogistics.Web.MainPage.CardRecovery.ReturnCard
{
    public partial class ReturnCardDetailedRpt : System.Web.UI.Page
    {   

        protected void Page_Load(object sender, EventArgs e)
        {
            string returnCardNo = Request.QueryString["returnCardNo"];//退货单号
            StringBuilder sbStr = new StringBuilder();
            sbStr.Append(" SELECT * FROM v_ReturnCardDetailed WHERE 1=1  and Issubmit=5");

            if (returnCardNo.Trim().Length > 0)
            {
                sbStr.Append(" and ReturnCardNo ='" + returnCardNo.Trim().ToUpper() + "'");//退货单号
            }
            sbStr.Append(" Order by ReturnCardNo,BoxNo,CardNo");
            OracleXMLReportData.GenNodeXmlData(this, sbStr.ToString(), true);

        }
    }
}